package com.sky.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.*;

@Mapper
public interface ReportMapper {
    @Select("select SUM(amount) from orders where order_time>#{date} and order_time<#{dateAddOne} and `status`=5")
    String getTurnoverStatisticsByDate(LocalDate date, LocalDate dateAddOne);

    Integer getUserList(LocalDate date, LocalDate dateAddOne);

    Integer getOrderCount(Map orderMap);

    LinkedList<Map<String, BigDecimal>> getSale(LocalDate startTime, LocalDate endTime);

//    Integer gettotalUserList(LocalDate dateAddOne);
}
